﻿CREATE FUNCTION [dbo].[clr_TigerOrderInfo]
(@orderNumber NVARCHAR (4000), @key NVARCHAR (4000), @timeOutInSeconds INT)
RETURNS 
     TABLE (
        [orderNo]      NVARCHAR (32) NULL,
        [custNo]       NVARCHAR (32) NULL,
        [itemNo]       NVARCHAR (32) NULL,
        [qty]          INT           NULL,
        [purchaseDate] SMALLDATETIME NULL,
        [Type]         NVARCHAR (16) NULL)
AS
 EXTERNAL NAME [Library].[UserDefinedFunctions].[clr_TigerOrderInfo]


GO
EXECUTE sp_addextendedproperty @name = N'AutoDeployed', @value = N'yes', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'FUNCTION', @level1name = N'clr_TigerOrderInfo';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyFile', @value = N'Rate.cs', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'FUNCTION', @level1name = N'clr_TigerOrderInfo';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyFileLine', @value = 62, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'FUNCTION', @level1name = N'clr_TigerOrderInfo';

